Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 6362620 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 728.1 MiB |
| Average record size in memory | 120.0 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 6 |
name_orig has a high cardinality: 6353307 distinct values | High cardinality |
name_dest has a high cardinality: 2722362 distinct values | High cardinality |
step is highly overall correlated with day | High correlation |
amount is highly overall correlated with oldbalance_dest and 3 other fields | High correlation |
oldbalance_org is highly overall correlated with newbalance_orig | High correlation |
newbalance_orig is highly overall correlated with oldbalance_org and 1 other fields | High correlation |
oldbalance_dest is highly overall correlated with amount and 2 other fields | High correlation |
newbalance_dest is highly overall correlated with amount and 2 other fields | High correlation |
diff_org_balance is highly overall correlated with amount and 2 other fields | High correlation |
diff_dest_balance is highly overall correlated with amount and 1 other fields | High correlation |
day is highly overall correlated with step | High correlation |
type is highly overall correlated with merchant_dest | High correlation |
merchant_dest is highly overall correlated with type | High correlation |
is_fraud is highly imbalanced (98.6%) | Imbalance |
is_flagged_fraud is highly imbalanced (> 99.9%) | Imbalance |
amount is highly skewed (γ1 = 30.99394948) | Skewed |
diff_org_balance is highly skewed (γ1 = -30.07475092) | Skewed |
diff_dest_balance is highly skewed (γ1 = -30.33109298) | Skewed |
name_orig is uniformly distributed | Uniform |
oldbalance_org has 2102449 (33.0%) zeros | Zeros |
newbalance_orig has 3609566 (56.7%) zeros | Zeros |
oldbalance_dest has 2704388 (42.5%) zeros | Zeros |
newbalance_dest has 2439433 (38.3%) zeros | Zeros |
diff_org_balance has 1361836 (21.4%) zeros | Zeros |
diff_dest_balance has 1032168 (16.2%) zeros | Zeros |
Reproduction
| Analysis started | 2023-02-05 11:53:20.689776 |
|---|---|
| Analysis finished | 2023-02-05 12:04:23.653997 |
| Duration | 11 minutes and 2.96 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
step
Real number (ℝ)
| Distinct | 743 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 243.39725 |
| Minimum | 1 |
|---|---|
| Maximum | 743 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 48.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 156 |
| median | 239 |
| Q3 | 335 |
| 95-th percentile | 490 |
| Maximum | 743 |
| Range | 742 |
| Interquartile range (IQR) | 179 |
Descriptive statistics
| Standard deviation | 142.33197 |
|---|---|
| Coefficient of variation (CV) | 0.58477232 |
| Kurtosis | 0.32907056 |
| Mean | 243.39725 |
| Median Absolute Deviation (MAD) | 92 |
| Skewness | 0.37517689 |
| Sum | 1.5486442 × 109 |
| Variance | 20258.39 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 19 | 51352 | 0.8% |
| 18 | 49579 | 0.8% |
| 187 | 49083 | 0.8% |
| 235 | 47491 | 0.7% |
| 307 | 46968 | 0.7% |
| 163 | 46352 | 0.7% |
| 139 | 46054 | 0.7% |
| 403 | 45155 | 0.7% |
| 43 | 45060 | 0.7% |
| 355 | 44787 | 0.7% |
| Other values (733) | 5890739 |
| Value | Count | Frequency (%) |
| 1 | 2708 | < 0.1% |
| 2 | 1014 | < 0.1% |
| 3 | 552 | < 0.1% |
| 4 | 565 | < 0.1% |
| 5 | 665 | < 0.1% |
| 6 | 1660 | < 0.1% |
| 7 | 6837 | 0.1% |
| 8 | 21097 | |
| 9 | 37628 | |
| 10 | 35991 |
| Value | Count | Frequency (%) |
| 743 | 8 | < 0.1% |
| 742 | 14 | |
| 741 | 22 | |
| 740 | 6 | < 0.1% |
| 739 | 10 | |
| 738 | 10 | |
| 737 | 10 | |
| 736 | 14 | |
| 735 | 12 | |
| 734 | 8 | < 0.1% |
type
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.5 MiB |
| CASH_OUT | |
|---|---|
| PAYMENT | |
| CASH_IN | |
| TRANSFER | |
| DEBIT | 41432 |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.422396 |
| Min length | 5 |
Characters and Unicode
| Total characters | 47225885 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PAYMENT |
|---|---|
| 2nd row | PAYMENT |
| 3rd row | TRANSFER |
| 4th row | CASH_OUT |
| 5th row | PAYMENT |
Common Values
| Value | Count | Frequency (%) |
| CASH_OUT | 2237500 | |
| PAYMENT | 2151495 | |
| CASH_IN | 1399284 | |
| TRANSFER | 532909 | 8.4% |
| DEBIT | 41432 | 0.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| cash_out | 2237500 | |
| payment | 2151495 | |
| cash_in | 1399284 | |
| transfer | 532909 | 8.4% |
| debit | 41432 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 6321188 | |
| T | 4963336 | |
| S | 4169693 | |
| N | 4083688 | |
| C | 3636784 | 7.7% |
| H | 3636784 | 7.7% |
| _ | 3636784 | 7.7% |
| E | 2725836 | 5.8% |
| O | 2237500 | 4.7% |
| U | 2237500 | 4.7% |
| Other values (8) | 9576792 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 43589101 | |
| Connector Punctuation | 3636784 | 7.7% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 6321188 | |
| T | 4963336 | |
| S | 4169693 | |
| N | 4083688 | |
| C | 3636784 | |
| H | 3636784 | |
| E | 2725836 | 6.3% |
| O | 2237500 | 5.1% |
| U | 2237500 | 5.1% |
| Y | 2151495 | 4.9% |
| Other values (7) | 7425297 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 3636784 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 43589101 | |
| Common | 3636784 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 6321188 | |
| T | 4963336 | |
| S | 4169693 | |
| N | 4083688 | |
| C | 3636784 | |
| H | 3636784 | |
| E | 2725836 | 6.3% |
| O | 2237500 | 5.1% |
| U | 2237500 | 5.1% |
| Y | 2151495 | 4.9% |
| Other values (7) | 7425297 |
Common
| Value | Count | Frequency (%) |
| _ | 3636784 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 47225885 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 6321188 | |
| T | 4963336 | |
| S | 4169693 | |
| N | 4083688 | |
| C | 3636784 | 7.7% |
| H | 3636784 | 7.7% |
| _ | 3636784 | 7.7% |
| E | 2725836 | 5.8% |
| O | 2237500 | 4.7% |
| U | 2237500 | 4.7% |
| Other values (8) | 9576792 |
amount
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 5316900 |
|---|---|
| Distinct (%) | 83.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 179861.9 |
| Minimum | 0 |
|---|---|
| Maximum | 92445517 |
| Zeros | 16 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 48.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2224.0995 |
| Q1 | 13389.57 |
| median | 74871.94 |
| Q3 | 208721.48 |
| 95-th percentile | 518634.2 |
| Maximum | 92445517 |
| Range | 92445517 |
| Interquartile range (IQR) | 195331.91 |
Descriptive statistics
| Standard deviation | 603858.23 |
|---|---|
| Coefficient of variation (CV) | 3.3573437 |
| Kurtosis | 1797.9567 |
| Mean | 179861.9 |
| Median Absolute Deviation (MAD) | 68393.655 |
| Skewness | 30.993949 |
| Sum | 1.1443929 × 1012 |
| Variance | 3.6464476 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10000000 | 3207 | 0.1% |
| 10000 | 88 | < 0.1% |
| 5000 | 79 | < 0.1% |
| 15000 | 68 | < 0.1% |
| 500 | 65 | < 0.1% |
| 100000 | 42 | < 0.1% |
| 21500 | 37 | < 0.1% |
| 120000 | 29 | < 0.1% |
| 135000 | 20 | < 0.1% |
| 0 | 16 | < 0.1% |
| Other values (5316890) | 6358969 |
| Value | Count | Frequency (%) |
| 0 | 16 | |
| 0.01 | 1 | < 0.1% |
| 0.02 | 3 | < 0.1% |
| 0.03 | 2 | < 0.1% |
| 0.04 | 1 | < 0.1% |
| 0.06 | 1 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.1 | 1 | < 0.1% |
| 0.11 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 92445516.64 | 1 | |
| 73823490.36 | 1 | |
| 71172480.42 | 1 | |
| 69886731.3 | 1 | |
| 69337316.27 | 1 | |
| 67500761.29 | 1 | |
| 66761272.21 | 1 | |
| 64234448.19 | 1 | |
| 63847992.58 | 1 | |
| 63294839.63 | 1 |
name_orig
Categorical
HIGH CARDINALITY UNIFORM
| Distinct | 6353307 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.5 MiB |
| C1902386530 | 3 |
|---|---|
| C363736674 | 3 |
| C545315117 | 3 |
| C724452879 | 3 |
| C1784010646 | 3 |
| Other values (6353302) |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.482323 |
| Min length | 5 |
Characters and Unicode
| Total characters | 66695040 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 6344009 ? |
|---|---|
| Unique (%) | 99.7% |
Sample
| 1st row | C1231006815 |
|---|---|
| 2nd row | C1666544295 |
| 3rd row | C1305486145 |
| 4th row | C840083671 |
| 5th row | C2048537720 |
Common Values
| Value | Count | Frequency (%) |
| C1902386530 | 3 | < 0.1% |
| C363736674 | 3 | < 0.1% |
| C545315117 | 3 | < 0.1% |
| C724452879 | 3 | < 0.1% |
| C1784010646 | 3 | < 0.1% |
| C1677795071 | 3 | < 0.1% |
| C1462946854 | 3 | < 0.1% |
| C1999539787 | 3 | < 0.1% |
| C2098525306 | 3 | < 0.1% |
| C400299098 | 3 | < 0.1% |
| Other values (6353297) | 6362590 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| c1902386530 | 3 | < 0.1% |
| c2098525306 | 3 | < 0.1% |
| c363736674 | 3 | < 0.1% |
| c1530544995 | 3 | < 0.1% |
| c1065307291 | 3 | < 0.1% |
| c2051359467 | 3 | < 0.1% |
| c1832548028 | 3 | < 0.1% |
| c400299098 | 3 | < 0.1% |
| c1976208114 | 3 | < 0.1% |
| c1999539787 | 3 | < 0.1% |
| Other values (6353297) | 6362590 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 8803448 | |
| C | 6362620 | |
| 2 | 6136135 | |
| 3 | 5699596 | |
| 4 | 5693146 | |
| 7 | 5669437 | |
| 5 | 5668010 | |
| 6 | 5667725 | |
| 0 | 5667074 | |
| 9 | 5665212 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 60332420 | |
| Uppercase Letter | 6362620 | 9.5% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 8803448 | |
| 2 | 6136135 | |
| 3 | 5699596 | |
| 4 | 5693146 | |
| 7 | 5669437 | |
| 5 | 5668010 | |
| 6 | 5667725 | |
| 0 | 5667074 | |
| 9 | 5665212 | |
| 8 | 5662637 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 6362620 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 60332420 | |
| Latin | 6362620 | 9.5% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 8803448 | |
| 2 | 6136135 | |
| 3 | 5699596 | |
| 4 | 5693146 | |
| 7 | 5669437 | |
| 5 | 5668010 | |
| 6 | 5667725 | |
| 0 | 5667074 | |
| 9 | 5665212 | |
| 8 | 5662637 |
Latin
| Value | Count | Frequency (%) |
| C | 6362620 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 66695040 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 8803448 | |
| C | 6362620 | |
| 2 | 6136135 | |
| 3 | 5699596 | |
| 4 | 5693146 | |
| 7 | 5669437 | |
| 5 | 5668010 | |
| 6 | 5667725 | |
| 0 | 5667074 | |
| 9 | 5665212 |
oldbalance_org
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 1845844 |
|---|---|
| Distinct (%) | 29.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 833883.1 |
| Minimum | 0 |
|---|---|
| Maximum | 59585040 |
| Zeros | 2102449 |
| Zeros (%) | 33.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 48.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 14208 |
| Q3 | 107315.18 |
| 95-th percentile | 5823702.3 |
| Maximum | 59585040 |
| Range | 59585040 |
| Interquartile range (IQR) | 107315.18 |
Descriptive statistics
| Standard deviation | 2888242.7 |
|---|---|
| Coefficient of variation (CV) | 3.4636062 |
| Kurtosis | 32.964879 |
| Mean | 833883.1 |
| Median Absolute Deviation (MAD) | 14208 |
| Skewness | 5.2491364 |
| Sum | 5.3056813 × 1012 |
| Variance | 8.3419457 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 2102449 | |
| 184 | 918 | < 0.1% |
| 133 | 914 | < 0.1% |
| 195 | 912 | < 0.1% |
| 164 | 909 | < 0.1% |
| 181 | 908 | < 0.1% |
| 109 | 908 | < 0.1% |
| 157 | 902 | < 0.1% |
| 146 | 899 | < 0.1% |
| 128 | 898 | < 0.1% |
| Other values (1845834) | 4252003 |
| Value | Count | Frequency (%) |
| 0 | 2102449 | |
| 0.05 | 1 | < 0.1% |
| 0.18 | 1 | < 0.1% |
| 0.21 | 1 | < 0.1% |
| 0.44 | 1 | < 0.1% |
| 0.67 | 1 | < 0.1% |
| 1 | 370 | < 0.1% |
| 1.02 | 1 | < 0.1% |
| 1.37 | 1 | < 0.1% |
| 1.38 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 59585040.37 | 1 | |
| 57316255.05 | 1 | |
| 50399045.08 | 1 | |
| 49585040.37 | 1 | |
| 47316255.05 | 1 | |
| 45674547.89 | 1 | |
| 44892193.09 | 1 | |
| 43818855.3 | 1 | |
| 43686616.33 | 1 | |
| 42542664.27 | 1 |
newbalance_orig
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 2682586 |
|---|---|
| Distinct (%) | 42.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 855113.67 |
| Minimum | 0 |
|---|---|
| Maximum | 49585040 |
| Zeros | 3609566 |
| Zeros (%) | 56.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 48.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 144258.41 |
| 95-th percentile | 5980262.3 |
| Maximum | 49585040 |
| Range | 49585040 |
| Interquartile range (IQR) | 144258.41 |
Descriptive statistics
| Standard deviation | 2924048.5 |
|---|---|
| Coefficient of variation (CV) | 3.4194852 |
| Kurtosis | 32.066985 |
| Mean | 855113.67 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.176884 |
| Sum | 5.4407633 × 1012 |
| Variance | 8.5500596 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 3609566 | |
| 5888.64 | 4 | < 0.1% |
| 15073.44 | 4 | < 0.1% |
| 5122 | 4 | < 0.1% |
| 36875.73 | 4 | < 0.1% |
| 10528.49 | 4 | < 0.1% |
| 904.13 | 4 | < 0.1% |
| 18392.51 | 4 | < 0.1% |
| 32926.52 | 4 | < 0.1% |
| 4277.69 | 4 | < 0.1% |
| Other values (2682576) | 2753018 |
| Value | Count | Frequency (%) |
| 0 | 3609566 | |
| 0.01 | 1 | < 0.1% |
| 0.03 | 1 | < 0.1% |
| 0.05 | 1 | < 0.1% |
| 0.12 | 1 | < 0.1% |
| 0.13 | 1 | < 0.1% |
| 0.18 | 1 | < 0.1% |
| 0.21 | 1 | < 0.1% |
| 0.23 | 1 | < 0.1% |
| 0.3 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 49585040.37 | 1 | |
| 47316255.05 | 1 | |
| 43686616.33 | 1 | |
| 43673802.21 | 1 | |
| 41690842.64 | 1 | |
| 41432359.46 | 1 | |
| 40399045.08 | 1 | |
| 39585040.37 | 1 | |
| 38946233.02 | 1 | |
| 38939424.03 | 1 |
name_dest
Categorical
| Distinct | 2722362 |
|---|---|
| Distinct (%) | 42.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.5 MiB |
| C1286084959 | 113 |
|---|---|
| C985934102 | 109 |
| C665576141 | 105 |
| C2083562754 | 102 |
| C248609774 | 101 |
| Other values (2722357) |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.481752 |
| Min length | 2 |
Characters and Unicode
| Total characters | 66691405 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2262704 ? |
|---|---|
| Unique (%) | 35.6% |
Sample
| 1st row | M1979787155 |
|---|---|
| 2nd row | M2044282225 |
| 3rd row | C553264065 |
| 4th row | C38997010 |
| 5th row | M1230701703 |
Common Values
| Value | Count | Frequency (%) |
| C1286084959 | 113 | < 0.1% |
| C985934102 | 109 | < 0.1% |
| C665576141 | 105 | < 0.1% |
| C2083562754 | 102 | < 0.1% |
| C248609774 | 101 | < 0.1% |
| C1590550415 | 101 | < 0.1% |
| C451111351 | 99 | < 0.1% |
| C1789550256 | 99 | < 0.1% |
| C1360767589 | 98 | < 0.1% |
| C1023714065 | 97 | < 0.1% |
| Other values (2722352) | 6361596 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| c1286084959 | 113 | < 0.1% |
| c985934102 | 109 | < 0.1% |
| c665576141 | 105 | < 0.1% |
| c2083562754 | 102 | < 0.1% |
| c248609774 | 101 | < 0.1% |
| c1590550415 | 101 | < 0.1% |
| c451111351 | 99 | < 0.1% |
| c1789550256 | 99 | < 0.1% |
| c1360767589 | 98 | < 0.1% |
| c1023714065 | 97 | < 0.1% |
| Other values (2722352) | 6361596 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 8799996 | |
| 2 | 6133780 | |
| 3 | 5704404 | |
| 4 | 5691070 | |
| 8 | 5675627 | |
| 9 | 5668861 | |
| 7 | 5665128 | |
| 0 | 5664751 | |
| 6 | 5662897 | |
| 5 | 5662271 | |
| Other values (2) | 6362620 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 60328785 | |
| Uppercase Letter | 6362620 | 9.5% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 8799996 | |
| 2 | 6133780 | |
| 3 | 5704404 | |
| 4 | 5691070 | |
| 8 | 5675627 | |
| 9 | 5668861 | |
| 7 | 5665128 | |
| 0 | 5664751 | |
| 6 | 5662897 | |
| 5 | 5662271 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 4211125 | |
| M | 2151495 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 60328785 | |
| Latin | 6362620 | 9.5% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 8799996 | |
| 2 | 6133780 | |
| 3 | 5704404 | |
| 4 | 5691070 | |
| 8 | 5675627 | |
| 9 | 5668861 | |
| 7 | 5665128 | |
| 0 | 5664751 | |
| 6 | 5662897 | |
| 5 | 5662271 |
Latin
| Value | Count | Frequency (%) |
| C | 4211125 | |
| M | 2151495 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 66691405 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 8799996 | |
| 2 | 6133780 | |
| 3 | 5704404 | |
| 4 | 5691070 | |
| 8 | 5675627 | |
| 9 | 5668861 | |
| 7 | 5665128 | |
| 0 | 5664751 | |
| 6 | 5662897 | |
| 5 | 5662271 | |
| Other values (2) | 6362620 |
oldbalance_dest
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 3614697 |
|---|---|
| Distinct (%) | 56.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1100701.7 |
| Minimum | 0 |
|---|---|
| Maximum | 3.5601589 × 108 |
| Zeros | 2704388 |
| Zeros (%) | 42.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 48.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 132705.66 |
| Q3 | 943036.71 |
| 95-th percentile | 5147229.7 |
| Maximum | 3.5601589 × 108 |
| Range | 3.5601589 × 108 |
| Interquartile range (IQR) | 943036.71 |
Descriptive statistics
| Standard deviation | 3399180.1 |
|---|---|
| Coefficient of variation (CV) | 3.0881938 |
| Kurtosis | 948.67413 |
| Mean | 1100701.7 |
| Median Absolute Deviation (MAD) | 132705.66 |
| Skewness | 19.921758 |
| Sum | 7.0033464 × 1012 |
| Variance | 1.1554425 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 2704388 | |
| 10000000 | 615 | < 0.1% |
| 20000000 | 219 | < 0.1% |
| 30000000 | 86 | < 0.1% |
| 40000000 | 31 | < 0.1% |
| 102 | 21 | < 0.1% |
| 198 | 19 | < 0.1% |
| 125 | 18 | < 0.1% |
| 160 | 18 | < 0.1% |
| 132 | 18 | < 0.1% |
| Other values (3614687) | 3657187 |
| Value | Count | Frequency (%) |
| 0 | 2704388 | |
| 0.01 | 1 | < 0.1% |
| 0.03 | 1 | < 0.1% |
| 0.13 | 1 | < 0.1% |
| 0.33 | 1 | < 0.1% |
| 0.37 | 1 | < 0.1% |
| 0.79 | 1 | < 0.1% |
| 1 | 7 | < 0.1% |
| 1.39 | 1 | < 0.1% |
| 1.64 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 356015889.4 | 1 | |
| 355553416.3 | 1 | |
| 355381433.6 | 1 | |
| 355380483.5 | 1 | |
| 355185537.1 | 1 | |
| 328194464.9 | 1 | |
| 327998074.2 | 1 | |
| 327963024 | 1 | |
| 327852121.4 | 1 | |
| 327827763.4 | 1 |
newbalance_dest
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 3555499 |
|---|---|
| Distinct (%) | 55.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1224996.4 |
| Minimum | 0 |
|---|---|
| Maximum | 3.5617928 × 108 |
| Zeros | 2439433 |
| Zeros (%) | 38.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 48.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 214661.44 |
| Q3 | 1111909.2 |
| 95-th percentile | 5515715.9 |
| Maximum | 3.5617928 × 108 |
| Range | 3.5617928 × 108 |
| Interquartile range (IQR) | 1111909.2 |
Descriptive statistics
| Standard deviation | 3674128.9 |
|---|---|
| Coefficient of variation (CV) | 2.9992978 |
| Kurtosis | 862.15651 |
| Mean | 1224996.4 |
| Median Absolute Deviation (MAD) | 214661.44 |
| Skewness | 19.352302 |
| Sum | 7.7941866 × 1012 |
| Variance | 1.3499223 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 2439433 | |
| 10000000 | 53 | < 0.1% |
| 971418.91 | 32 | < 0.1% |
| 19169204.93 | 29 | < 0.1% |
| 1254956.07 | 25 | < 0.1% |
| 16532032.16 | 25 | < 0.1% |
| 1412484.09 | 22 | < 0.1% |
| 4743010.67 | 21 | < 0.1% |
| 1178808.14 | 21 | < 0.1% |
| 7364724.84 | 21 | < 0.1% |
| Other values (3555489) | 3922938 |
| Value | Count | Frequency (%) |
| 0 | 2439433 | |
| 0.01 | 1 | < 0.1% |
| 0.33 | 1 | < 0.1% |
| 1.39 | 1 | < 0.1% |
| 1.64 | 1 | < 0.1% |
| 1.74 | 1 | < 0.1% |
| 2.15 | 1 | < 0.1% |
| 2.45 | 1 | < 0.1% |
| 2.71 | 1 | < 0.1% |
| 2.76 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 356179278.9 | 1 | |
| 356015889.4 | 1 | |
| 355553416.3 | 2 | |
| 355381433.6 | 1 | |
| 355380483.5 | 1 | |
| 355185537.1 | 1 | |
| 328431698.2 | 1 | |
| 328194464.9 | 1 | |
| 327998074.2 | 1 | |
| 327963024 | 1 |
is_fraud
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.5 MiB |
| 0 | |
|---|---|
| 1 | 8213 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 6362620 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 6354407 | |
| 1 | 8213 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 6354407 | |
| 1 | 8213 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 6354407 | |
| 1 | 8213 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 6362620 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 6354407 | |
| 1 | 8213 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 6362620 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 6354407 | |
| 1 | 8213 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6362620 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 6354407 | |
| 1 | 8213 | 0.1% |
is_flagged_fraud
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.5 MiB |
| 0 | |
|---|---|
| 1 | 16 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 6362620 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 6362604 | |
| 1 | 16 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 6362604 | |
| 1 | 16 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 6362604 | |
| 1 | 16 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 6362620 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 6362604 | |
| 1 | 16 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 6362620 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 6362604 | |
| 1 | 16 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6362620 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 6362604 | |
| 1 | 16 | < 0.1% |
diff_org_balance
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 907958 |
|---|---|
| Distinct (%) | 14.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -201092.08 |
| Minimum | -92445516 |
|---|---|
| Maximum | 0 |
| Zeros | 1361836 |
| Zeros (%) | 21.4% |
| Negative | 5000784 |
| Negative (%) | 78.6% |
| Memory size | 48.5 MiB |
Quantile statistics
| Minimum | -92445516 |
|---|---|
| 5-th percentile | -700716.05 |
| Q1 | -249640.25 |
| median | -68677 |
| Q3 | -2954 |
| 95-th percentile | 0 |
| Maximum | 0 |
| Range | 92445516 |
| Interquartile range (IQR) | 246686.25 |
Descriptive statistics
| Standard deviation | 606650.43 |
|---|---|
| Coefficient of variation (CV) | -3.0167793 |
| Kurtosis | 1753.2688 |
| Mean | -201092.08 |
| Median Absolute Deviation (MAD) | 68677 |
| Skewness | -30.074751 |
| Sum | -1.2794725 × 1012 |
| Variance | 3.6802474 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1361836 | 21.4% |
| -10000000 | 1085 | < 0.1% |
| -1000 | 168 | < 0.1% |
| -10000 | 133 | < 0.1% |
| -20000 | 121 | < 0.1% |
| -84 | 108 | < 0.1% |
| -1944 | 108 | < 0.1% |
| -2514 | 105 | < 0.1% |
| -1982 | 105 | < 0.1% |
| -510 | 104 | < 0.1% |
| Other values (907948) | 4998747 |
| Value | Count | Frequency (%) |
| -92445516 | 1 | |
| -73823490 | 1 | |
| -71172480 | 1 | |
| -69886731 | 1 | |
| -69337316 | 1 | |
| -67500761 | 1 | |
| -66761272 | 1 | |
| -64234448 | 1 | |
| -63847992 | 1 | |
| -63294839 | 1 |
| Value | Count | Frequency (%) |
| 0 | 1361836 | |
| -1 | 65 | < 0.1% |
| -2 | 70 | < 0.1% |
| -3 | 59 | < 0.1% |
| -4 | 59 | < 0.1% |
| -5 | 71 | < 0.1% |
| -6 | 83 | < 0.1% |
| -7 | 85 | < 0.1% |
| -8 | 79 | < 0.1% |
| -9 | 71 | < 0.1% |
diff_dest_balance
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 1197049 |
|---|---|
| Distinct (%) | 18.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -304156.23 |
| Minimum | -1.8489103 × 108 |
|---|---|
| Maximum | 12930418 |
| Zeros | 1032168 |
| Zeros (%) | 16.2% |
| Negative | 5273086 |
| Negative (%) | 82.9% |
| Memory size | 48.5 MiB |
Quantile statistics
| Minimum | -1.8489103 × 108 |
|---|---|
| 5-th percentile | -1056983.3 |
| Q1 | -308391 |
| median | -27748 |
| Q3 | -3815 |
| 95-th percentile | 0 |
| Maximum | 12930418 |
| Range | 1.9782145 × 108 |
| Interquartile range (IQR) | 304576 |
Descriptive statistics
| Standard deviation | 1362380.9 |
|---|---|
| Coefficient of variation (CV) | -4.4792142 |
| Kurtosis | 1554.52 |
| Mean | -304156.23 |
| Median Absolute Deviation (MAD) | 27748 |
| Skewness | -30.331093 |
| Sum | -1.9352305 × 1012 |
| Variance | 1.8560817 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1032168 | 16.2% |
| -2216 | 168 | < 0.1% |
| -1181 | 168 | < 0.1% |
| -1005 | 166 | < 0.1% |
| -1339 | 166 | < 0.1% |
| -1722 | 166 | < 0.1% |
| -2752 | 166 | < 0.1% |
| -497 | 165 | < 0.1% |
| -1797 | 165 | < 0.1% |
| -1259 | 165 | < 0.1% |
| Other values (1197039) | 5328957 |
| Value | Count | Frequency (%) |
| -184891033 | 1 | |
| -164559608 | 1 | |
| -147646980 | 1 | |
| -142344960 | 1 | |
| -139773462 | 1 | |
| -138674632 | 1 | |
| -135767972 | 1 | |
| -135489952 | 1 | |
| -135001522 | 1 | |
| -133522544 | 1 |
| Value | Count | Frequency (%) |
| 12930418 | 1 | |
| 9385209 | 1 | |
| 5672835 | 1 | |
| 5315828 | 1 | |
| 5263390 | 1 | |
| 5114161 | 1 | |
| 4834325 | 1 | |
| 4755039 | 1 | |
| 4565838 | 1 | |
| 4525018 | 1 |
merchant_dest
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 48.5 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 6362620 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 4211125 | |
| 1 | 2151495 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 4211125 | |
| 1 | 2151495 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4211125 | |
| 1 | 2151495 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 6362620 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4211125 | |
| 1 | 2151495 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 6362620 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4211125 | |
| 1 | 2151495 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6362620 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4211125 | |
| 1 | 2151495 |
day
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.491907 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 48.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 7 |
| median | 10 |
| Q3 | 14 |
| 95-th percentile | 21 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 5.9218122 |
|---|---|
| Coefficient of variation (CV) | 0.56441716 |
| Kurtosis | 0.33230145 |
| Mean | 10.491907 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.37784774 |
| Sum | 66756016 |
| Variance | 35.06786 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 1 | 574255 | 9.0% |
| 2 | 455238 | 7.2% |
| 8 | 449637 | 7.1% |
| 6 | 441005 | 6.9% |
| 13 | 428583 | 6.7% |
| 17 | 425766 | 6.7% |
| 7 | 420583 | 6.6% |
| 9 | 417919 | 6.6% |
| 11 | 417859 | 6.6% |
| 15 | 401282 | 6.3% |
| Other values (21) | 1930493 |
| Value | Count | Frequency (%) |
| 1 | 574255 | |
| 2 | 455238 | |
| 3 | 1070 | < 0.1% |
| 4 | 28240 | 0.4% |
| 5 | 9789 | 0.2% |
| 6 | 441005 | |
| 7 | 420583 | |
| 8 | 449637 | |
| 9 | 417919 | |
| 10 | 392945 |
| Value | Count | Frequency (%) |
| 31 | 272 | < 0.1% |
| 30 | 11287 | 0.2% |
| 29 | 54890 | |
| 28 | 14661 | 0.2% |
| 27 | 8578 | 0.1% |
| 26 | 13885 | 0.2% |
| 25 | 57853 | |
| 24 | 32709 | |
| 23 | 51012 | |
| 22 | 53437 |
| step | amount | oldbalance_org | newbalance_orig | oldbalance_dest | newbalance_dest | diff_org_balance | diff_dest_balance | day | type | is_fraud | is_flagged_fraud | merchant_dest | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| step | 1.000 | 0.001 | -0.006 | -0.011 | -0.005 | -0.005 | -0.002 | 0.019 | 0.998 | 0.011 | 0.059 | 0.006 | 0.010 |
| amount | 0.001 | 1.000 | 0.048 | -0.071 | 0.595 | 0.670 | -0.879 | -0.576 | 0.007 | 0.050 | 0.049 | 0.014 | 0.022 |
| oldbalance_org | -0.006 | 0.048 | 1.000 | 0.803 | 0.024 | -0.008 | 0.042 | 0.391 | -0.006 | 0.213 | 0.031 | 0.003 | 0.162 |
| newbalance_orig | -0.011 | -0.071 | 0.803 | 1.000 | 0.044 | -0.094 | 0.031 | 0.621 | -0.012 | 0.238 | 0.019 | 0.005 | 0.180 |
| oldbalance_dest | -0.005 | 0.595 | 0.024 | 0.044 | 1.000 | 0.936 | -0.590 | -0.199 | -0.003 | 0.017 | 0.002 | 0.000 | 0.022 |
| newbalance_dest | -0.005 | 0.670 | -0.008 | -0.094 | 0.936 | 1.000 | -0.610 | -0.375 | -0.003 | 0.027 | 0.002 | 0.000 | 0.025 |
| diff_org_balance | -0.002 | -0.879 | 0.042 | 0.031 | -0.590 | -0.610 | 1.000 | 0.328 | -0.007 | 0.050 | 0.000 | 0.014 | 0.022 |
| diff_dest_balance | 0.019 | -0.576 | 0.391 | 0.621 | -0.199 | -0.375 | 0.328 | 1.000 | 0.015 | 0.085 | 0.067 | 0.010 | 0.040 |
| day | 0.998 | 0.007 | -0.006 | -0.012 | -0.003 | -0.003 | -0.007 | 0.015 | 1.000 | 0.011 | 0.062 | 0.006 | 0.011 |
| type | 0.011 | 0.050 | 0.213 | 0.238 | 0.017 | 0.027 | 0.050 | 0.085 | 0.011 | 1.000 | 0.059 | 0.005 | 1.000 |
| is_fraud | 0.059 | 0.049 | 0.031 | 0.019 | 0.002 | 0.002 | 0.000 | 0.067 | 0.062 | 0.059 | 1.000 | 0.043 | 0.026 |
| is_flagged_fraud | 0.006 | 0.014 | 0.003 | 0.005 | 0.000 | 0.000 | 0.014 | 0.010 | 0.006 | 0.005 | 0.043 | 1.000 | 0.001 |
| merchant_dest | 0.010 | 0.022 | 0.162 | 0.180 | 0.022 | 0.025 | 0.022 | 0.040 | 0.011 | 1.000 | 0.026 | 0.001 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| step | type | amount | name_orig | oldbalance_org | newbalance_orig | name_dest | oldbalance_dest | newbalance_dest | is_fraud | is_flagged_fraud | diff_org_balance | diff_dest_balance | merchant_dest | day | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | PAYMENT | 9839.6400 | C1231006815 | 170136.0000 | 160296.3600 | M1979787155 | 0.0000 | 0.0000 | 0 | 0 | 0 | -9839 | 1 | 1 |
| 1 | 1 | PAYMENT | 1864.2800 | C1666544295 | 21249.0000 | 19384.7200 | M2044282225 | 0.0000 | 0.0000 | 0 | 0 | 0 | -1864 | 1 | 1 |
| 2 | 1 | TRANSFER | 181.0000 | C1305486145 | 181.0000 | 0.0000 | C553264065 | 0.0000 | 0.0000 | 1 | 0 | 0 | -181 | 0 | 1 |
| 3 | 1 | CASH_OUT | 181.0000 | C840083671 | 181.0000 | 0.0000 | C38997010 | 21182.0000 | 0.0000 | 1 | 0 | 0 | 21001 | 0 | 1 |
| 4 | 1 | PAYMENT | 11668.1400 | C2048537720 | 41554.0000 | 29885.8600 | M1230701703 | 0.0000 | 0.0000 | 0 | 0 | 0 | -11668 | 1 | 1 |
| 5 | 1 | PAYMENT | 7817.7100 | C90045638 | 53860.0000 | 46042.2900 | M573487274 | 0.0000 | 0.0000 | 0 | 0 | 0 | -7817 | 1 | 1 |
| 6 | 1 | PAYMENT | 7107.7700 | C154988899 | 183195.0000 | 176087.2300 | M408069119 | 0.0000 | 0.0000 | 0 | 0 | 0 | -7107 | 1 | 1 |
| 7 | 1 | PAYMENT | 7861.6400 | C1912850431 | 176087.2300 | 168225.5900 | M633326333 | 0.0000 | 0.0000 | 0 | 0 | 0 | -7861 | 1 | 1 |
| 8 | 1 | PAYMENT | 4024.3600 | C1265012928 | 2671.0000 | 0.0000 | M1176932104 | 0.0000 | 0.0000 | 0 | 0 | -1353 | -4024 | 1 | 1 |
| 9 | 1 | DEBIT | 5337.7700 | C712410124 | 41720.0000 | 36382.2300 | C195600860 | 41898.0000 | 40348.7900 | 0 | 0 | 0 | -3788 | 0 | 1 |
| step | type | amount | name_orig | oldbalance_org | newbalance_orig | name_dest | oldbalance_dest | newbalance_dest | is_fraud | is_flagged_fraud | diff_org_balance | diff_dest_balance | merchant_dest | day | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6362610 | 742 | TRANSFER | 63416.9900 | C778071008 | 63416.9900 | 0.0000 | C1812552860 | 0.0000 | 0.0000 | 1 | 0 | 0 | -63416 | 0 | 31 |
| 6362611 | 742 | CASH_OUT | 63416.9900 | C994950684 | 63416.9900 | 0.0000 | C1662241365 | 276433.1800 | 339850.1700 | 1 | 0 | 0 | -126833 | 0 | 31 |
| 6362612 | 743 | TRANSFER | 1258818.8200 | C1531301470 | 1258818.8200 | 0.0000 | C1470998563 | 0.0000 | 0.0000 | 1 | 0 | 0 | -1258818 | 0 | 31 |
| 6362613 | 743 | CASH_OUT | 1258818.8200 | C1436118706 | 1258818.8200 | 0.0000 | C1240760502 | 503464.5000 | 1762283.3300 | 1 | 0 | 0 | -2517637 | 0 | 31 |
| 6362614 | 743 | TRANSFER | 339682.1300 | C2013999242 | 339682.1300 | 0.0000 | C1850423904 | 0.0000 | 0.0000 | 1 | 0 | 0 | -339682 | 0 | 31 |
| 6362615 | 743 | CASH_OUT | 339682.1300 | C786484425 | 339682.1300 | 0.0000 | C776919290 | 0.0000 | 339682.1300 | 1 | 0 | 0 | -679364 | 0 | 31 |
| 6362616 | 743 | TRANSFER | 6311409.2800 | C1529008245 | 6311409.2800 | 0.0000 | C1881841831 | 0.0000 | 0.0000 | 1 | 0 | 0 | -6311409 | 0 | 31 |
| 6362617 | 743 | CASH_OUT | 6311409.2800 | C1162922333 | 6311409.2800 | 0.0000 | C1365125890 | 68488.8400 | 6379898.1100 | 1 | 0 | 0 | -12622818 | 0 | 31 |
| 6362618 | 743 | TRANSFER | 850002.5200 | C1685995037 | 850002.5200 | 0.0000 | C2080388513 | 0.0000 | 0.0000 | 1 | 0 | 0 | -850002 | 0 | 31 |
| 6362619 | 743 | CASH_OUT | 850002.5200 | C1280323807 | 850002.5200 | 0.0000 | C873221189 | 6510099.1100 | 7360101.6300 | 1 | 0 | 0 | -1700005 | 0 | 31 |